﻿CREATE TABLE [acms].[Users]
(
	Id int NOT NULL Identity(1,1), 
	SiteId int,
	FirstName varchar(50),
	LastName varchar(50),
	UserName varchar(50),
	DateOfBirth DateTime,
	EmailAddress varchar(100),
	Gender tinyint,
	Address1 varchar(100),
	Address2 varchar(100),
	Town varchar(50),
	PostCode varchar(20),
	MobileTel varchar(20),
	Created DateTime,
	Password varchar(255),
	Salt int,
	Deleted bit,
	VersionId TimeStamp
);
